Stat_Rev tab

The Stat_Rev (Statistics and Revenue) tab is where you review and adjust current year projection amounts and next year’s budget for Statistics, Revenues, and Deductions.

NOTE: Provide comments in any red comment cells.

Global Drivers – Summarizes the Budget Assumptions used to drive initial projections for the department.

Key Department Statistics – Includes department-specific statistics that drive the variable gross revenue, variable costs, and variable labor calculations in the workbook.

Global drivers are used to apply the overall organization growth assumptions to the department statistic. You can make adjustments in the Mar-Jun change for CY as well as % Adjust and Amt Adjust columns for NY Budget.

Key statistics, such as patient days by Nursing unit, are defined in the Budget Statistics driver.

If a statistic Dept/Acct combination is listed in the Budget Assumptions driver, no adjustments may be made in the budget plan file.

Other Non-Key Statistic – Displays other statistics captured for the department, but do not drive any other calculations in the workbook.

Patient Revenue – Summarizes all revenue. Displays projections based on historical revenue per unit plus price increase (revenue adjustments) times volume.
Patient Revenue Detail – Displays detailed patient revenue, both in-patient and out-patient, by specific account.
Other Revenue – Models the projection and budget for other operating revenue accounts, typically using a Fixed Revenue calc method, which uses the projected value as the starting point for budget.

You can make adjustments in the Mar-Jun change, % Adjust, and Amt Adjust columns.

NOTE: Make sure to update and review this section for comments and monthly budget spreads.

Calc Methods – Stat_Rev Sheet

Calc Method	Description
Allowance	Calculate deductions based on a percentage of gross revenue.
BadDebt	Calculate bad debt based on a percentage of gross revenue.
Detail	Zeros base revenue calculations.
FixedRevenue	Allows changes to the projected year as well as budget. Usually used for other operating revenue accounts. Select the monthly spread from the drop-down.
GlobalRevenue	Pushes revenue or deduction calculations to the budget plan file from Budget Assumptions. End users cannot change the totals or the spread in the budget plan files. Only users with administrative rights can update the calculations.
GlobalSum	This SPM allows you to budget for an account at a percentage of the total of specific other account(s) on the Stat_Rev tab within the same workbook.
InputMonthly	Month by month input.
IP_Per_Unit	This revenue calc method is now an independent calculation of IP revenue by account using the historical revenue per unit.
IP_Payor	Calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Only use this calc method if the GL gross revenue account structure is by payor.
OP_Per_Unit	This revenue calc method is now an independent calculation of OP revenue by account using the historical revenue per unit.
OP_Payor	This calc method calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Use this calc method only if the GL gross revenue account structure is by payor.
Oth_Per_Unit	This revenue calc method is now an independent calculation of Other Patient revenue by account using the historical revenue per unit.
Oth_Payor	This calc method calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Only use this calc method if the GL gross revenue account structure is by payor.
NoBudget	Brings in historical values into the budget plan file, but the budget for next year will be zero, and cannot be changed.
Statistic	Calculates projected and budget key statistics.
Statistic_Oth	Calculates projected and budget non-key statistics based on their relationship to the key statistic.
Revenue_Stat	This revenue calc method allows you to define the statistic account from the Stat_Rev tab to use as the basis of the per unit calculation and the multiplier for the budget. For example, there my be an Other Department statistic in the OR for implant cases that should be used to drive the Revenue-Implant account.
Add New Detail	Zero-based expense calculations when adding a new account. Inputs are done on the Detail tab in the budget plan file.
Add New Fixed Revenue	Use this new revenue calc method to add a new Fixed Revenue account to the Stat_Rev tab.
Add New Input Monthly	Use this new revenue or statistic calc method to add a new account to the Stat_Rev tab.
Add New Statistic	Use this new statistic calc method to add a new key statistic account to the Stat_Rev tab.
Add New Statistic_Oth	Use this new statistic calc method to add a new Other Statistic account to the Stat_Rev tab.

Provider Version Only: Calc Methods – Stat_Rev Sheet

If your organization has purchased the Provider module, you have access to the following additional calc methods:

Calc Method	Description
ProviderRev	Transfers Revenue calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables.
ProviderStat	Transfers Statistic calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables.
ProviderComp	Transfers Salary calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables. NOTE: Provider Light Version Only: Calc Methods – Stat_Rev Sheet If your organization has purchased the Provider module, you can access the following additional calc methods if using the Provider Light. Provider_Simple_Rev – Transfers Revenue calculations from the Provider Simple Rev tab to the Stat_Rev tab to save to the Financial Data Tables. If you GL structure has multiple revenue accounts for Provider revenue, then apply the calculation method Provider_Simple_Rev to each revenue account. Provider_Simple_Stat – Transfers Statistic calculations from the Provider Simple Rev tab to the Stat_Rev tab to save to the Financial Data Tables. Assign this to the key statistic you are using as your driver stat on the Provider tab. For example, when using WRVU as your Driver stat, add Provider_Simple_Stat to the GL acct on the ACCT dimension table for WRVUs.

Calc Method

Description

ProviderRev

Transfers Revenue calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables.

ProviderStat

Transfers Statistic calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables.

ProviderComp

Transfers Salary calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables.

NOTE: Provider Light Version Only: Calc Methods – Stat_Rev Sheet

If your organization has purchased the Provider module, you can access the following additional calc methods if using the Provider Light.

Provider_Simple_Rev – Transfers Revenue calculations from the Provider Simple Rev tab to the Stat_Rev tab to save to the Financial Data Tables. If you GL structure has multiple revenue accounts for Provider revenue, then apply the calculation method Provider_Simple_Rev to each revenue account.
Provider_Simple_Stat – Transfers Statistic calculations from the Provider Simple Rev tab to the Stat_Rev tab to save to the Financial Data Tables. Assign this to the key statistic you are using as your driver stat on the Provider tab. For example, when using WRVU as your Driver stat, add Provider_Simple_Stat to the GL acct on the ACCT dimension table for WRVUs.